UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '65i6MiYNq3Od00SKqyfQ84X4xAKlT2gV7TgdhPEQIL0='
WHERE
key_id = '0e8cd34f441ade9fd62bfcfab148ffa10cb66eb6a2c246a30c7ab82bf269a1f6'
AND (
token = '65i6MiYNq3Od00SKqyfQ84X4xAKlT2gV7TgdhPEQIL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)