UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9Pwui759AjdPw8YYiZICIH5vf2IZR3AFAsQRI1SVKw='
WHERE
key_id = '93549b4580b62a94c9578dafccbb397b40ffa178be005144b4dd6b56fa8c34b1'
AND (
token = 'J9Pwui759AjdPw8YYiZICIH5vf2IZR3AFAsQRI1SVKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)