UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCh0wF8tpYr8giQI0a2OyZJNd0QZdOLRFcO/Mmen7Wc='
WHERE
key_id = '1a1a9f7bf7479930908c26c63f16a0935fdfcd131a715c6cb7e53d545450e0c1'
AND (
token = 'gCh0wF8tpYr8giQI0a2OyZJNd0QZdOLRFcO/Mmen7Wc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)