UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x+CTfqgKPNcYeU1xyuxqgekUOfJ41hP6mWinkJEsfmM='
WHERE
key_id = 'b78c6d0e32cf4fb0c61eca27e532a202e9de65d397e1a9177aa379f4adc45670'
AND (
token = 'x+CTfqgKPNcYeU1xyuxqgekUOfJ41hP6mWinkJEsfmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)