UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x9wkwmQY/IIMwBOzpWdbbXBfpTyr8bamSK6rQ7evPl0='
WHERE
key_id = '7474ff6789d84d96cb2f4fcdcf1215ddf1bda8ecc9010a19ad183ec8dc01c22f'
AND (
token = 'x9wkwmQY/IIMwBOzpWdbbXBfpTyr8bamSK6rQ7evPl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)