UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LW5otBz56xvEp2537ro/SC1SQJqKHfq8voExquJWp44='
WHERE
key_id = '35a83b5779413a008684c4f0850e30688a707eb9b0d02f0fa0cc06ad78f1cf4b'
AND (
token = 'LW5otBz56xvEp2537ro/SC1SQJqKHfq8voExquJWp44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)