UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGu0nGEH2yrJicZ5irPNSAYOxzDzrgbMCiKKTBw9Jkw='
WHERE
key_id = '64015d0ecdbe9f1470c7dc884a2b17d87589f65aecf4e2e155b9e5da744b4fe0'
AND (
token = 'bGu0nGEH2yrJicZ5irPNSAYOxzDzrgbMCiKKTBw9Jkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)