UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NOxOYbG2lVHELiK3yQACAha60v9WzpjmWHLiYx64VpE='
WHERE
key_id = 'a44478e89488fd28f2543faf2e2eb775c65212a4d5f76c461aa8f9d7c9e075b1'
AND (
token = 'NOxOYbG2lVHELiK3yQACAha60v9WzpjmWHLiYx64VpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)