UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHfhn3qLXEaMA7NlUPFHq0FwJpR0rPdO1cwQLWFSfMM='
WHERE
key_id = '3f13c1d96605f04bd60c9e7113bb862902a4955c2ad3f3442d563ab5712230d5'
AND (
token = 'xHfhn3qLXEaMA7NlUPFHq0FwJpR0rPdO1cwQLWFSfMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)