UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'loN8y8alRMg457RoVBpnAgh0iBSkWKf+fE69CRufcCI='
WHERE
key_id = 'de018f94ca898050a2f05c2a0c62131b12ab25f1d3b91a56294cc321e5a9c28c'
AND (
token = 'loN8y8alRMg457RoVBpnAgh0iBSkWKf+fE69CRufcCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)