UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I6T1kte1BuPY2xBI9B/96ktGauLcEEsOqo5dNmjjfkw='
WHERE
key_id = '5523c76ff59b3fce36cd6351c2156d1beff21f58e235a0c651c403ab09f95046'
AND (
token = 'I6T1kte1BuPY2xBI9B/96ktGauLcEEsOqo5dNmjjfkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)