UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NhQ4XH97OJ92++kFGPg0qtYr2+NeBbUroVHszycN48w='
WHERE
key_id = '78895544d1991d09bc561d347959220f697d689fb844a7e841b93e89e6717b64'
AND (
token = 'NhQ4XH97OJ92++kFGPg0qtYr2+NeBbUroVHszycN48w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)