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