UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9hn9vGtr00Yu18abUCO4REmstnYcO/mFWS1ciLYPEE='
WHERE
key_id = '58b9a02be71717f7729c8b5535cce44971e5c6b388c2379c414db968cbf49d56'
AND (
token = 'U9hn9vGtr00Yu18abUCO4REmstnYcO/mFWS1ciLYPEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)