UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FUfP3LWTz+Z8uLYdjvuBonOxCr8Bidbfu+9REPiTENk='
WHERE
key_id = 'd588a0c982e4cb0f5ba3ff09df346b4b96a2dc2d2256d9e41268fb9b14c96b46'
AND (
token = 'FUfP3LWTz+Z8uLYdjvuBonOxCr8Bidbfu+9REPiTENk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)