UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cqHNR77Inz4WYvMAmmUQJQsG46Jdl17GFuzFE5PVIn8='
WHERE
key_id = '74a344c1ac41916276a42db276f63b9de3700744aa362afc20c067af12d88cd5'
AND (
token = 'cqHNR77Inz4WYvMAmmUQJQsG46Jdl17GFuzFE5PVIn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)