UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VQwXAfER+WlXLurX119QEE1jjj2Kdj7wZgDZSWfAhAA='
WHERE
key_id = 'f0f9a73c4a6a5012fc5a1c4d7a72e8f77f3ed478c63d0c4f6b299b0e57d50bb1'
AND (
token = 'VQwXAfER+WlXLurX119QEE1jjj2Kdj7wZgDZSWfAhAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)