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