UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpYjvLYHUst69D4oZHL4jnu1SizxFTs5GfdJzn8/xXE='
WHERE
key_id = '982a6e6502dc40eeb8a16f310e0573c0f61c4eea601bdfe2da14e8aa90467211'
AND (
token = 'zpYjvLYHUst69D4oZHL4jnu1SizxFTs5GfdJzn8/xXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)