UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KHv1tSdRlEeXf4/u0zQ/UhCwM/X5J/Z6zk22k7CgW5E='
WHERE
key_id = '685dd19cef137452f6e215331b971132b71f02e25281a25f2df4cca8ca6fa8b7'
AND (
token = 'KHv1tSdRlEeXf4/u0zQ/UhCwM/X5J/Z6zk22k7CgW5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)