UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gEiIeeGNJEqvaHGlwYHUi26B6ZSHoRm1cdhv06w7gjg='
WHERE
key_id = 'd78e68ffa0ca8886da0ca81f38339ee1dbf0f48cf3af7193165ef4a326f2a426'
AND (
token = 'gEiIeeGNJEqvaHGlwYHUi26B6ZSHoRm1cdhv06w7gjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)