UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '01zNMvRIQCcBIGg486u4ind0ZwuEQspFpW8irikPYS0='
WHERE
key_id = '482bc2782ad13323061611b1063f6aeba9e64ff5465fc3f53189f74706733ecc'
AND (
token = '01zNMvRIQCcBIGg486u4ind0ZwuEQspFpW8irikPYS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)