UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4NB9k0QA3TUhZpSrbhCZf46Gt6a44uzVlw2VV0N/xGw='
WHERE
key_id = 'cb0047e5196175fcc3c7db0d152e2f8aa3db68545b0d277889d1afe493471eba'
AND (
token = '4NB9k0QA3TUhZpSrbhCZf46Gt6a44uzVlw2VV0N/xGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)