UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9tObrVUEBB3kE94qbnWt9jntTtr8jEOEgvkpUvrxFc='
WHERE
key_id = '9cbccaaf909883d97d7cceef2f7863b2ae3ca573910662b301b80133eaa3518f'
AND (
token = 'z9tObrVUEBB3kE94qbnWt9jntTtr8jEOEgvkpUvrxFc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)