UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BSnBwdJmSg9tUa/BnBaGiik/kTARYTtBzxM3GzWSGw='
WHERE
key_id = '588c436336f29242ceb6e8e87a50f1cc9147a9fb4f7babf3125714f9ecd544f6'
AND (
token = '7BSnBwdJmSg9tUa/BnBaGiik/kTARYTtBzxM3GzWSGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)