UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q6Rly/dVnjT4UxZ3yV21KOLaJkpzF66HQDErKp3mrhw='
WHERE
key_id = 'b4c8afa0940a94387db92cd5299ca6c4c7f95535ae950e197588872d0f7ae29f'
AND (
token = 'q6Rly/dVnjT4UxZ3yV21KOLaJkpzF66HQDErKp3mrhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)