UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eNLbnk3oSTWw13FnghU5y517NB3GwZRIvGDxWCScGV0='
WHERE
key_id = '32d28cfb5f1d51f486fc8cb617e6ef73e52f8222f3b71b921c2200dcf4a27300'
AND (
token = 'eNLbnk3oSTWw13FnghU5y517NB3GwZRIvGDxWCScGV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)