UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7IiTM4ZpD7LjlcVc/nLrl/wObBsZiYewhABn4x/kkQ='
WHERE
key_id = '10955a635ef26d0dc6c3cdd898acd7a9b940042f345c24989fcec7e1d7586051'
AND (
token = 'x7IiTM4ZpD7LjlcVc/nLrl/wObBsZiYewhABn4x/kkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)