UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X7OIzAuG3ClWM0kE7KsAmHyxPyMfasRBbtH8Ty8e90U='
WHERE
key_id = 'c2bbc32cf1a6abcfa106955750a57cc0523b21923c013ce3c00d241e0d5a272a'
AND (
token = 'X7OIzAuG3ClWM0kE7KsAmHyxPyMfasRBbtH8Ty8e90U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)