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