UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v2zOBygXRH5cMI0J0Wb1SIV6AXvnIWUXL+rpSAMtKLw='
WHERE
key_id = '67b7d9f064ff4c57f855ee8e5289b5e4a9b5492142458741dd411476db6be602'
AND (
token = 'v2zOBygXRH5cMI0J0Wb1SIV6AXvnIWUXL+rpSAMtKLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)