UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xyzUa7PbnyN0A1myMH4R4nvm+qEGOhzdOjaPkdZfmz4='
WHERE
key_id = '4ea650d4020883a1fc3fe0b5580d705fd7c8a7e93c6e01af1e95172751ee3bc1'
AND (
token = 'xyzUa7PbnyN0A1myMH4R4nvm+qEGOhzdOjaPkdZfmz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)