UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AmgVL+QDJiYYuS/mqiIVW2UwifIG7EcunqbVSPDSauk='
WHERE
key_id = 'bf8142fc15e60a3f0e36b78f36726bde597cef63f6f9cf6b202a64a605ed2bf7'
AND (
token = 'AmgVL+QDJiYYuS/mqiIVW2UwifIG7EcunqbVSPDSauk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)