UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4faScQ1VQEQRlLse+pbhKpAvAZbVg3WlecraUg1DrhY='
WHERE
key_id = '2795848f7b618fe3de428deac4df686c45b9633b6ac3c780d3cdadcce6d589b2'
AND (
token = '4faScQ1VQEQRlLse+pbhKpAvAZbVg3WlecraUg1DrhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)