UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm8gRdsRcN4wmxPDL5uhlhMGTL+w93ohe2fUPWj9hktk='
WHERE
key_id = '78ac8760ac05a4457006a236739a57ab83062e9d5bc0a6984fc9079d1aafd85e'
AND (
token = 'm8gRdsRcN4wmxPDL5uhlhMGTL+w93ohe2fUPWj9hktk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)