UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9GNLF5ym3FzqZM2Yzse/5cgHbiSkjJ45xcfFIry7NWY='
WHERE
key_id = 'd5678e1848b3862a44a719ec0c89fd0cb66ec47e511988a384e9856989931f3d'
AND (
token = '9GNLF5ym3FzqZM2Yzse/5cgHbiSkjJ45xcfFIry7NWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)