UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jXJFwCenYG2DG10pYFwxIcVhY7bleIQzo8zMmIDAgu8='
WHERE
key_id = '76ed28feeb43d731de83d14cb601bed6a7debe993a82b818d64dc185a68851e9'
AND (
token = 'jXJFwCenYG2DG10pYFwxIcVhY7bleIQzo8zMmIDAgu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)