UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '66hENOh9yWnCgvSp8ibCMo0eFkWViVHOmNX2IzFkaWw='
WHERE
key_id = 'e3e3c5b1beaadbf2ef71a05a6972ce80224d6ea4784cc6792b7d893a95d891c6'
AND (
token = '66hENOh9yWnCgvSp8ibCMo0eFkWViVHOmNX2IzFkaWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)