UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2/MPWJMILKjE3XfpS4RjgE7VSPQ2m5UQLc3zFgXtcFU='
WHERE
key_id = '847a19c600c26a980b49784082b263e7d1274f0caea6c9622e0a8911a5bbab32'
AND (
token = '2/MPWJMILKjE3XfpS4RjgE7VSPQ2m5UQLc3zFgXtcFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)