UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMvxpFLY2ceOT+9TGqd4JBLl4WS6XFyPqI5gNcL9txs='
WHERE
key_id = '672f26967e0b36e880951db1b1016611a865834bc38a0223935ba8d05da6fcac'
AND (
token = 'BMvxpFLY2ceOT+9TGqd4JBLl4WS6XFyPqI5gNcL9txs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)